SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and type ='T'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newfound Lake NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Stunning Red Fox unit , one of the closest to the beach ! Spend your days memorized by the Newfound lake and Cardigan views from this immaculate unit . All remodeled and ready to go just bring your furniture and start enjoying life at the lake ! Enjoy a respite in all 4 seasons from this truly great unit at Red Fox village , walk the short path to the beach and use the tunnel under the road to access the 400 ft shared beach with common boat dock , canoe and kayak racks , moorings (wait list) , beach cabana for your sand chairs . The beach is one of the finest on the lake with walk in to a sandy bottom, swim area , raft , shared day dock . This is all facing west for unbelievable sunsets. If you want a place at the lake this is the one for you as they do not come along often ..
Description:Overlooking Newfound Lake, this cute-as-can-be cottage has fantastic Lake views and was built from the ground up in 2018. When you enter, you will love the open-concept living area with cathedral ceilings and shiplap walls. The custom-designed kitchen features granite countertops, stainless steel appliances, and a full pantry with ample storage space. The primary bedroom is on the first floor with a full bath and shower. On the top level is a loft/bedroom with twin beds and broad views of the Lake. A spacious deck is perfect for drinking coffee and watching the sunrise. The private sugar sandy beach is 132 feet of shoreline. There is a shared swim raft, a storage cottage near the beach for your chairs or toys, a kayak rack, and a morning/dock waiting list. Designated parking onsite. The owner is an NH-licensed broker. Newfound Lake is known as one of the cleanest lakes in the world, with freshwater springs that feed its source. Fish, swim, or relax on the beach.